package com.dhecp.project.finance.controller;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.apache.shiro.authz.annotation.Logical;
import org.apache.shiro.authz.annotation.RequiresPermissions;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.servlet.ModelAndView;

import com.dhecp.common.annotation.Log;
import com.dhecp.common.annotation.RepeatSubmit;
import com.dhecp.common.config.Global;
import com.dhecp.common.core.domain.AjaxResult;
import com.dhecp.common.core.page.TableDataInfo;
import com.dhecp.common.enums.BusinessType;
import com.dhecp.common.utils.MessageUtils;
import com.dhecp.common.utils.TypeUtils;
import com.dhecp.core.constant.ModuleTable;
import com.dhecp.core.utils.DateUtil;
import com.dhecp.core.utils.ExportExcelUtils;
import com.dhecp.core.utils.PdfUtil;
import com.dhecp.framework.util.ShiroUtils;
import com.dhecp.project.base.domain.CompanyInfo;
import com.dhecp.project.base.service.CompanyInfoService;
import com.dhecp.project.common.controller.BaseModuleController;
import com.dhecp.project.common.domain.ModuleNidAndBid;
import com.dhecp.project.common.service.ModuleNidAndBidService;
import com.dhecp.project.finance.domain.OperateServiceChargeApply;
import com.dhecp.project.finance.service.OperateServiceChargeApplyService;
import com.dhecp.project.flowable.domain.ActHistoricActivity;
import com.dhecp.project.flowable.service.ActProcessService;
import com.dhecp.project.logstics.domain.FbaBox;
import com.dhecp.project.system.domain.SysDictionaryForExport;
import com.dhecp.project.system.domain.SysUserInfo;
import com.dhecp.project.system.service.SysDictionaryForFieldService;
import com.dhecp.project.system.service.SysUserInfoService;

/**
 * 运营费用申请 控制层 
 * @author DH-Xxj
 * @version 2022年10月20日
 */
@Controller
@RequestMapping("/finance/operateservicechargeapply")
public class OperateServiceChargeApplyController extends BaseModuleController{

	private String prefix = "finance/operateservicechargeapply";
    private String moduleTable = ModuleTable.OPERATE_SERVICE_CHARGE_APPLY;
    private String moduleTableGroup = ModuleTable.OPERATE_SERVICE_CHARGE_APPLY_GROUP;


    @Autowired
    private ActProcessService actProcessService;
    @Autowired
    private CompanyInfoService companyInfoService;
    @Autowired
    private OperateServiceChargeApplyService businessService;
    @Autowired
    private SysUserInfoService sysUserInfoService;
    
    @Autowired
    private ModuleNidAndBidService moduleNidAndBidService;
    
    @Autowired
    private SysDictionaryForFieldService dictionaryForFieldService;
    
    /**
     * 打开查询列表页
     * @param params
     * @return
     * @author DH-Xxj
     */
	@RequiresPermissions("finance:operateservicechargeapply:view")
    @GetMapping()
    public ModelAndView listPage(@RequestParam Map<String, Object> params){
		params.put("moduleTable", moduleTable);
    	params.put("entity", new OperateServiceChargeApply()); //生成表格gridColumns对应的实体，用于获取实体属性生成表格字段
    	params.put("prefix","finance/finance"); //页面路径
        params.put("checkBox", "yes");
    	ModelAndView mv = this.openListPage(params);
    	mv.addObject("finance", "operateservicechargeapply");
		return mv;
    }
	
	/**
     * 打开分组（整单）查询列表页
     * @param params
     * @return
     * @author DH-Xxj
     */
	@RequiresPermissions("finance:operateservicechargeapply:view")
    @GetMapping("/listgrouppage")
    public ModelAndView listGroupPage(@RequestParam Map<String, Object> params){
		params.put("moduleTable", moduleTableGroup);
		params.put("moduleTableForButton", moduleTable);	//使用单据moduleTable的按钮状态
    	params.put("entity", new OperateServiceChargeApply()); //生成表格gridColumns对应的实体，用于获取实体属性生成表格字段
    	params.put("prefix","finance/finance"); //页面路径
    	ModelAndView mv = this.openListPage(params);
    	mv.addObject("finance", "operateservicechargeapply/group");
		return mv;
    }
    
	/**
	 * 打开制单页
	 * @param nid 必要参数：单据编码（新增时传默认值 0 ，修改、查看时传单据实际值）
	 * @return
	 * @author DH-Xxj
	 */
    @RequiresPermissions("finance:operateservicechargeapply:view")
    @GetMapping("/edit")
    public ModelAndView editPage(@RequestParam Map<String, Object> params){  
		if (params.get("nid") == null || params.get("nid") == ""){
        	params.put("nid", "0");
		}      
    	params.put("moduleTable", moduleTable);
    	params.put("entity", new OperateServiceChargeApply()); //用于获取实体属性名取代对应字典字段名，解决大小写敏感问题
    	params.put("moduleUrl", prefix); //页面上级路径
    	params.put("prefix", prefix + "/operateservicechargeapply_edit"); //页面路径
    	
    	try{
            Map<String, Object> headData = new HashMap<String, Object>();		//表头的业务数据
//          SysModuleSet moduleSet = sysModuleSetService.queryModuleSet(params);//单据设置信息
            OperateServiceChargeApply businessData = businessService.queryFirstRecord(params);
        	if (businessData == null){ //未查询到对应单据，页面初始化值
        		ModuleNidAndBid moduleNidAndBid = moduleNidAndBidService.queryModuleNidAndBidInitial(params);
        		OperateServiceChargeApply businessDataNew = new OperateServiceChargeApply();
            	businessDataNew.setNid("0");
            	businessDataNew.setBid(moduleNidAndBid.getBid());
            	businessDataNew.setCreateTime(new Date());
            	businessDataNew.setCid(ShiroUtils.getMandatorCid());
            	businessDataNew.setCidName(ShiroUtils.getMandatorCidName());
            	businessDataNew.setbUser(ShiroUtils.getMandatorId());
            	businessDataNew.setbUserName(ShiroUtils.getMandatorName());
            	businessDataNew.setbDept(ShiroUtils.getMandatorDeptPath());
            	businessDataNew.setbDeptName(ShiroUtils.getMandatorDeptName());
            	businessDataNew.setbPosition(ShiroUtils.getMandatorPositionNameDa());
            	businessDataNew.setaUser(ShiroUtils.getUserId());
            	businessDataNew.setaUserName(ShiroUtils.getUserName());
            	businessDataNew.setaDept(ShiroUtils.getUserDeptPath());
            	businessDataNew.setaDeptName(ShiroUtils.getUserDeptName());
            	businessDataNew.setaPosition(ShiroUtils.getUserPositionNameDa());
        		headData = TypeUtils.entityToMap(businessDataNew);
        	}else{
        		headData = TypeUtils.entityToMap(businessData);
        	}
        	params.put("headData", headData); //表头的业务数据
        	
        	params.put("checkBox", "yes"); //生成表格gridColumns时包含复选
            ModelAndView mv = this.openEditPage(params);
            return mv;
    	}catch(Exception e){
//    		return this.gotoModelAndViewErrorPage(this.getExceptionMessage(e));	//简单信息
    		return this.gotoModelAndViewErrorPage(e.getMessage());	//详细信息
    	}

    }
    
    /**
     * 打开流转页
     * @param fType 必要参数：审核类型（flow_go：流转，flow_back：退回）
	 * @param infoMap 必要参数：非网格字段（包括所有显示和隐藏的字段），json格式字符串
     * @return
     * @author DH-Xxj
     */
	@RequiresPermissions("finance:operateservicechargeapply:flow")
	@PostMapping("/flowpage")
	@ResponseBody
    public AjaxResult flowPage(@RequestParam Map<String, Object> params){
		params.put("moduleTable", moduleTable);
		params.put("prefix", prefix);
//		String flowUrl = flowPageUrl(params);
//		return redirect(flowUrl);
		return openFlowPage(params);
    }
	
	/**
	 * 制单页 明细数据
	 * @param nid 必要参数：当前 单据编码
	 * @return
	 * @author DH-Xxj
	 */
    @RequiresPermissions("finance:operateservicechargeapply:list")
	@GetMapping("/listbynid")
    @ResponseBody
    public TableDataInfo listByNid(@RequestParam Map<String, Object> params){
		if (params.get("nid") == null || params.get("nid") == ""){
			return getDataTable(MessageUtils.message("module.error.lack.nid"));
		}
		params.put("moduleTable", moduleTable);
        List<OperateServiceChargeApply> list = new ArrayList<OperateServiceChargeApply>();
        try {
        	list = businessService.queryListByNid(params);
        } catch (Exception e) {
            e.printStackTrace();
            return getDataTable(this.getExceptionMessage(e).toString());            
        }
        return getDataTable(list);
    }

	/**
	 * 查询前一单NID、BID
	 * @param nid 必要参数：当前 单据编码
	 * @return AjaxResult (data.nid 前一单NID， data.bid 前一单BID)
	 * @author DH-Xxj
	 */
    @RequiresPermissions("finance:operateservicechargeapply:view")
    @GetMapping("/lastnid")
    @ResponseBody
    public AjaxResult lastNid(@RequestParam Map<String, Object> params){
		params.put("moduleTable", moduleTable);
    	AjaxResult ajaxResult = new AjaxResult();
        try {
            ajaxResult = businessService.queryLastNid(params);
        }catch (Exception e) {
            ajaxResult = AjaxResult.error(this.getExceptionMessage(e));
        }
        return ajaxResult;
    }

	/**
	 * 查询后一单NID、BID
	 * @param nid 必要参数：当前 单据编码
	 * @return AjaxResult (data.nid 后一单NID， data.bid 后一单BID)
	 * @author DH-Xxj
	 */
    @RequiresPermissions("finance:operateservicechargeapply:view")
    @GetMapping("/nextnid")
    @ResponseBody
    public AjaxResult nextNid(@RequestParam Map<String, Object> params){
		params.put("moduleTable", moduleTable);
    	AjaxResult ajaxResult = new AjaxResult();
        try {
            ajaxResult = businessService.queryNextNid(params);
        }catch (Exception e) {
            ajaxResult = AjaxResult.error(this.getExceptionMessage(e));
        }
        return ajaxResult;
    }

	/**
	 * 查询页 列表数据
	 * @param params
	 * @return
	 * @author DH-Xxj
	 */
    @RequiresPermissions("finance:operateservicechargeapply:list")
	@GetMapping("/list")
    @ResponseBody
    public TableDataInfo list(@RequestParam Map<String, Object> params){
		params.put("moduleTable", moduleTable);
        List<OperateServiceChargeApply> list = new ArrayList<OperateServiceChargeApply>();
        try {
        	list = businessService.queryList(params);
        } catch (Exception e) {
            e.printStackTrace();
            return getDataTable(this.getExceptionMessage(e).toString());            
        }
        return getDataTable(list);
    }
    
    /**
	 * 分组（整单）查询页 列表数据
	 * @param params
	 * @return
	 * @author DH-Xxj
	 */
    @RequiresPermissions("finance:operateservicechargeapply:list")
	@GetMapping("/group/list")
    @ResponseBody
    public TableDataInfo listGroup(@RequestParam Map<String, Object> params){
		params.put("moduleTable", moduleTableGroup);	//获取网格字段、查询条件字段、数据权限条件字段等
		params.put("jurisdictionModuleTable", moduleTable);	//使用单据moduleTable分配的数据权限
        List<OperateServiceChargeApply> list = new ArrayList<OperateServiceChargeApply>();
        try {
        	list = businessService.queryGroupList(params);
        } catch (Exception e) {
            e.printStackTrace();
            return getDataTable(this.getExceptionMessage(e).toString());            
        }
        return getDataTable(list);
    }

    /**
     * 数据导出Excel
     * @param params
     * @return
     * @throws Exception
     * @author DH-Xxj
     */
    @RequiresPermissions("finance:operateservicechargeapply:export")
    @Log(title = "运营费用申请数据导出", businessType = BusinessType.EXPORT)
    @GetMapping("/export")
    @ResponseBody
    @RepeatSubmit
    public AjaxResult export(@RequestParam Map<String, Object> params) throws Exception {
		params.put("moduleTable", moduleTable);
    	params.put("entity", new OperateServiceChargeApply()); 
    	
        List<OperateServiceChargeApply> list = businessService.queryList(params);
        
    	params.put("getFieldAttributesType", "export");
    	List<SysDictionaryForExport> fieldList = dictionaryForFieldService.queryExportFieldList(params);
        ExportExcelUtils<OperateServiceChargeApply> util = new ExportExcelUtils<OperateServiceChargeApply>(moduleTable,new OperateServiceChargeApply());
        return util.exportExcel(list, fieldList, "运营费用申请数据", "export");
    }
    
    /**
     * 分组（整单）数据导出Excel
     * @param params
     * @return
     * @throws Exception
     * @author DH-Xxj
     */
    @RequiresPermissions("finance:operateservicechargeapply:export")
    @Log(title = "运营费用申请整单数据导出", businessType = BusinessType.EXPORT)
    @GetMapping("/group/export")
    @ResponseBody
    @RepeatSubmit
    public AjaxResult exportGroup(@RequestParam Map<String, Object> params) throws Exception {
		params.put("moduleTable", moduleTableGroup);	//获取网格字段、查询条件字段、数据权限条件字段等
		params.put("jurisdictionModuleTable", moduleTable);	//使用单据moduleTable分配的数据权限
    	params.put("entity", new OperateServiceChargeApply()); 
        
    	List<OperateServiceChargeApply> list = businessService.queryGroupList(params);
        
        params.put("getFieldAttributesType", "export");
    	List<SysDictionaryForExport> fieldList = dictionaryForFieldService.queryExportFieldList(params);
        ExportExcelUtils<OperateServiceChargeApply> util = new ExportExcelUtils<OperateServiceChargeApply>(moduleTable,new OperateServiceChargeApply());
        return util.exportExcel(list, fieldList, "运营费用申请整单数据", "export");
    }

    /**
     * 导出Excel导入模板
     * @param params
     * @return
     * @throws Exception
     * @author DH-Xxj
     */
    @RequiresPermissions("finance:operateservicechargeapply:import")
    @Log(title = "运营费用申请数据导出", businessType = BusinessType.EXPORT)
    @GetMapping("/exporttemplate")
    @ResponseBody
    @RepeatSubmit
    public AjaxResult exportTemplate(@RequestParam Map<String, Object> params) throws Exception {
		params.put("moduleTable", moduleTable);
    	params.put("entity", new OperateServiceChargeApply()); 
    	
    	params.put("getFieldAttributesType", "template");
    	List<SysDictionaryForExport> fieldList = dictionaryForFieldService.queryExportFieldList(params);
        ExportExcelUtils<OperateServiceChargeApply> util = new ExportExcelUtils<OperateServiceChargeApply>(moduleTable,new OperateServiceChargeApply());
        return util.exportExcel(null, fieldList, "运营费用申请导入模板", "template");
    }
    
	/**
	 * 保存数据
	 * @param infoMap 必要参数：非网格字段（包括头部、底部所有显示和隐藏的字段）
	 * @param infoItems 必要参数：对应实体类的json格式字符串
	 * @return
	 * @author DH-Xxj
	 */
    @RequiresPermissions(value={"finance:operateservicechargeapply:add","finance:operateservicechargeapply:edit","finance:operateservicechargeapply:delete"},logical=Logical.OR)
    @Log(title = "运营费用申请", businessType = BusinessType.UPDATE)
    @PostMapping("/editpost")
    @ResponseBody
    @RepeatSubmit
    public AjaxResult editSave(@RequestParam Map<String, Object> params){
		params.put("moduleTable", moduleTable);
    	AjaxResult ajaxResult = new AjaxResult();   
        try {
            ajaxResult= businessService.saveData(params);
        }catch (Exception e) {
            ajaxResult = AjaxResult.error(this.getExceptionMessage(e));
        }
        return ajaxResult;
    }

    /**
     * 流转
	 * @param infoMap 必要参数：非网格字段（包括头部、底部所有显示和隐藏的字段）
	 * @param infoItems 必要参数：对应实体类的json格式字符串（仅需 guid）
     * @return
     * @author DH-Xxj
     */
    @RequiresPermissions("finance:operateservicechargeapply:flow")
    @Log(title = "运营费用申请", businessType = BusinessType.FLOWGO)
    @PostMapping("/flowgopost")
    @ResponseBody
    @RepeatSubmit
    public AjaxResult flowGoSave(@RequestParam Map<String, Object> params){    	
		params.put("moduleTable", moduleTable);
    	AjaxResult ajaxResult = new AjaxResult();   
        try {
            ajaxResult= businessService.updateFlowGo(params);
        }catch (Exception e) {
            ajaxResult = AjaxResult.error(this.getExceptionMessage(e));
        }
        return ajaxResult;
    }

    /**
     * 退回
	 * @param infoMap 必要参数：非网格字段（包括头部、底部所有显示和隐藏的字段）
	 * @param infoItems 必要参数：对应实体类的json格式字符串（仅需 guid）
     * @return
     * @author DH-Xxj
     */
    @RequiresPermissions("finance:operateservicechargeapply:flow")
    @Log(title = "运营费用申请", businessType = BusinessType.FLOWBACK)
    @PostMapping("/flowbackpost")
    @ResponseBody
    @RepeatSubmit
    public AjaxResult flowBackSave(@RequestParam Map<String, Object> params){		
		params.put("moduleTable", moduleTable);
    	AjaxResult ajaxResult = new AjaxResult();    	
        try {
            ajaxResult= businessService.updateFlowBack(params);
        }catch (Exception e) {
            ajaxResult = AjaxResult.error(this.getExceptionMessage(e));
        }
        return ajaxResult;
    }

    /**
     *
     * @param params
     * @return
     */
    @PostMapping("/generatePDF")
    @ResponseBody
    public AjaxResult generatePDF(String bid){

        AjaxResult ajaxResult = new AjaxResult();
        
        if (bid == null || bid.length() == 0) {
			return AjaxResult.error("单据不能为空");
		}
        	
        try {

            String pdfFileName = "/" + bid + ".pdf";
        	
            // 生成PDF到指定目录下
            String dir = Global.getProfile();
            Map<String, Object> param = new HashMap<String, Object>();
        	param.put("moduleTable", moduleTable);
        	param.put("entity", new FbaBox());
        	param.put("bid", bid);
        	List<OperateServiceChargeApply> listReimbursementApply = businessService.queryList(param);
        	OperateServiceChargeApply reimbursementApply = listReimbursementApply.get(0);
        	if (listReimbursementApply == null || listReimbursementApply.size() == 0) {
    			return AjaxResult.error("单据不存在");
			}
    		// 单据总额
        	BigDecimal bpriceAll = BigDecimal.ZERO;
        	for(OperateServiceChargeApply entity : listReimbursementApply) {
        		// 单据总额累加
        		bpriceAll = bpriceAll.add(new BigDecimal(entity.getbPrice()));
        	}
        	
        	// 明细数据
        	List<PdfUtil.BaoXiaoDto.DetailDto> detailArr = new ArrayList<PdfUtil.BaoXiaoDto.DetailDto>();
        	
        	// 流程审批过程
            List<ActHistoricActivity> historicActivityList = actProcessService.queryActHistoricActivityByProcInstId(reimbursementApply.getProcInstId());
        	List<PdfUtil.BaoXiaoDto.RowDto> rows = new ArrayList<PdfUtil.BaoXiaoDto.RowDto>();
        	for(ActHistoricActivity entity : historicActivityList) {
        		
        		String opeTime = entity.getEndTimeFormat();
        		String opeUser = entity.getAssigneeName();
        		String opeResult = entity.getResultStatusName();
        		String opeOpinion = entity.getComment();
        		String fileName = "--";
        		PdfUtil.BaoXiaoDto.RowDto row = new PdfUtil.BaoXiaoDto.RowDto(opeTime, opeUser, opeResult, opeOpinion, fileName);
        		rows.add(row);
        	}
        	
        	Map<String, Object> param2 = new HashMap<String, Object>();
        	param2.put("vId", reimbursementApply.getCid());
        	CompanyInfo companyInfo = companyInfoService.queryCompanyInfoByVId(param2);
        	SysUserInfo sysUserInfo = sysUserInfoService.queryByUserId(reimbursementApply.getaUser());

        	String title = "运营费用申请单";
        	String createCompany = companyInfo.getvName();
        	String createTime = DateUtil.getYYYY_MM_DD_HH_mm_ss(reimbursementApply.getCreateTime());
        	String code = reimbursementApply.getBid();
        	String applyUser = reimbursementApply.getaUser() + "/" + sysUserInfo.getUserName();
        	String applyDept = sysUserInfo.getDeptName() + "/" + reimbursementApply.getaPosition();
        	String payType = reimbursementApply.getvJyLx();
        	String payAccount = reimbursementApply.getPartnerName() + "/" + reimbursementApply.getvKhh() + "/" + reimbursementApply.getvYhZh();
        	String payAmount = bpriceAll.setScale(2, BigDecimal.ROUND_HALF_UP).toString();
        	String remark = reimbursementApply.getvZdbz();
        	String printTime = DateUtil.getYYYY_MM_DD_HH_mm_ss(new Date());
        	String printUser = ShiroUtils.getMandatorName();
        	String printDept = ShiroUtils.getMandatorDeptName();
            PdfUtil.BaoXiaoDto dto = new PdfUtil.BaoXiaoDto(title, createCompany, createTime, code, applyUser, applyDept, payType, payAccount, payAmount, remark, printTime, printUser, printDept, detailArr, rows);
            PdfUtil.generateFinancePdf(dir, pdfFileName, dto);
            String data = "/profile" + pdfFileName;
            ajaxResult = AjaxResult.success("配货清单打印",data);
        }catch (Exception e) {
            ajaxResult = AjaxResult.error(this.getExceptionMessage(e));
        }
        return ajaxResult;
    }


	/**
	 * 修改记账时间
	 * @return
	 * @author DH-Xxj
	 */
	@RequiresPermissions("finance:operateservicechargeapply:edit")
	@Log(title = "修改记账时间", businessType = BusinessType.UPDATE)
	@PostMapping("/xgxxpost")
	@ResponseBody
	@RepeatSubmit
	public AjaxResult updateFsQk(@RequestParam Map<String, Object> params){
		params.put("moduleTable", moduleTable);
		AjaxResult ajaxResult = new AjaxResult();
		try {
			ajaxResult= businessService.updateWriteTime(params);
		}catch (Exception e) {
			ajaxResult = AjaxResult.error(this.getExceptionMessage(e));
		}
		return ajaxResult;
	}
}
